Updating Table Properties

Table properties are classified as technical and business properties. You can update these properties for a table and use user defined fields to enter additional properties of a table.

To update table properties, follow these steps:

  1. Go to Application Menu > Data Catalog > Metadata Manager > Explore.
  2. On the Explore tab, click an environment tile to view its details and tables.
  3. In the Data Catalog pane, click a table.

    4. By default, the Columns tab opens.

  4. Click Options.
    The available options appear.
  5. Click Edit Table.
    The Edit Table Form appears.

  6. Enter appropriate values in the fields. Fields marked with a red asterisk are mandatory. Refer to the following table for field descriptions.

    7. Field Name

    Sub-Field

    Description

    Technical Properties

    Name

    Specifies the physical name of the table.

    For example, Account or Currency.

    Schema Name

    Specifies the schema name of the table.

    For example, dbo.

    No of Rows

    Specifies the total number of rows in the table.

    For example, 100.

    Synonym Reference

    Specifies the synonym reference for the table.

    For example, Sales_Rep_Information.

    This field is autopopulated during the metadata scan. You cannot enter it manually.

    File Type

    Specifies the file type of the table if the table is in a file-based environment.

    For example, MS Excel.

    File Location

    Specifies the location of the files.

    Entity Type

    Specifies the entity type of the new component. It is autopopulated with Table.

    Business Details

    Logical Name

    Specifies the logical name of the table.

    For example, if the physical name of a table is DIM_Customer, then the logical name of the table is Customer Dimension.

    Definition

    Specifies the definition of the table.

    For example: The table contains five columns with emp ID column as the primary key.

    Expanded Logical Name

    Specifies the expanded logical name of the table.

    For example, if the physical name of a table is RM_Resource, then the expanded logical name of the table is RM Sales Representative.

    You can configure expanded logical name of tables in bulk at system and environment level.

    Comments

    Specifies comments about the table.

    For example: The table contains details of the employees.

    JSON Physical Name

    Specifies the JSON physical name of the table if the table is in a JSON environment.

    Class

    Specifies the table class property.

    For more information on configuring table class, refer to Configuring Table and Column Class topic.

    Alias

    Specifies the alias name of the table.

    For example, Sales_Representative_Table.

    Used in Gap Analysis

    Specifies whether the table is being used as part of a gap analysis to check table usage in mappings.

    Select the check box if the table is used in gap analysis.

    For more information on performing table gap analysis, refer to the Performing Table Gap Analysis topic.

    Governance Responsibilities

    Data Steward

    Specifies the name of the data steward responsible for the table.

    For example, Jane Doe.

    Users assigned with the Legacy Data Steward role appear as drop down options. You can assign this role to a user in the Resource Manager.

    To assign data steward, select a data steward from the drop down options. For more information on assigning roles and users, refer to the Updating Data Governance Assignments topic.

    Classification

    Sensitive Data Indicator (SDI) Classification

    Specifies the sensitivity data indicator (SDI) classification of the table. Also, you can add multiple classifications to a table.

    For example, PHI, Confidential.

    For more information on configuring SDI classifications refer to the Configuring Sensitive Data Indicator Classifications topic.

    Sensitive Data Indicator (SDI) Description

    Specifies the description of the SDI classification.

    For example: Protected Health Information.

    The field autopopulates based on the SDI classification.

    Miscellaneous

    Business Entity Type

    Specifies the database type of business entity.

    Tags

    Specifies tags of the column.

    For example, PII.

    Click Tags and select an existing tag or enter a tag name to create one on the fly.
  7. Click .

    8. The table properties are updated.

    You can use user defined fields with different UI labels. For more information on using UI labels for user defined fields, refer to the Configuring Language Settings topic.

    You can also hide user defined fields. For more information on hiding user defined fields, refer to the Displaying User Defined Fields topic.